Diamonds EDA Extended Report

Dataset statistics

Number of variables	10
Number of observations	4989
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	1
Duplicate rows (%)	< 0.1%
Total size in memory	428.7 KiB
Average record size in memory	88.0 B

Variable types

Numeric	10

Alerts

Dataset has 1 (< 0.1%) duplicate rows	Duplicates
`carat` is highly overall correlated with `price` and 3 other fields	High correlation
`price` is highly overall correlated with `carat` and 3 other fields	High correlation
`x` is highly overall correlated with `carat` and 3 other fields	High correlation
`y` is highly overall correlated with `carat` and 3 other fields	High correlation
`z` is highly overall correlated with `carat` and 3 other fields	High correlation
`cut` has 158 (3.2%) zeros	Zeros
`color` has 248 (5.0%) zeros	Zeros
`clarity` has 64 (1.3%) zeros	Zeros

Reproduction

Analysis started	2024-04-22 03:20:44.933850
Analysis finished	2024-04-22 03:20:55.299689
Duration	10.37 seconds
Software version	ydata-profiling v0.0.dev0
Download configuration	config.json

carat
Real number (ℝ)

HIGH CORRELATION

Distinct	202
Distinct (%)	4.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.79411706

Minimum	0.23
Maximum	4.13
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.0 KiB

Quantile statistics

Minimum	0.23
5-th percentile	0.3
Q1	0.4
median	0.7
Q3	1.04
95-th percentile	1.67
Maximum	4.13
Range	3.9
Interquartile range (IQR)	0.64

Descriptive statistics

Standard deviation	0.46798101
Coefficient of variation (CV)	0.58930985
Kurtosis	1.1571249
Mean	0.79411706
Median Absolute Deviation (MAD)	0.32
Skewness	1.0760861
Sum	3961.85
Variance	0.21900622
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.3	249	5.0%
1.01	228	4.6%
0.31	207	4.1%
0.32	192	3.8%
0.7	167	3.3%
0.9	143	2.9%
1	142	2.8%
0.41	124	2.5%
0.4	121	2.4%
0.5	117	2.3%
Other values (192)	3299	66.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.23	37	0.7%
0.24	12	0.2%
0.25	17	0.3%
0.26	30	0.6%
0.27	24	0.5%
0.28	14	0.3%
0.29	12	0.2%
0.3	249	5.0%
0.31	207	4.1%
0.32	192	3.8%

Value	Count	Frequency (%)
4.13	1	< 0.1%
3.01	2	< 0.1%
2.53	1	< 0.1%
2.52	2	< 0.1%
2.51	1	< 0.1%
2.5	2	< 0.1%
2.48	1	< 0.1%
2.47	1	< 0.1%
2.44	1	< 0.1%
2.42	2	< 0.1%

cut
Real number (ℝ)

ZEROS

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.7610744

Minimum	0
Maximum	4
Zeros	158
Zeros (%)	3.2%
Negative	0
Negative (%)	0.0%
Memory size	78.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	3
Q3	4
95-th percentile	4
Maximum	4
Range	4
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.0355742
Coefficient of variation (CV)	0.37506205
Kurtosis	-0.037420432
Mean	2.7610744
Median Absolute Deviation (MAD)	1
Skewness	-0.68946759
Sum	13775
Variance	1.0724139
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=5)

Value	Count	Frequency (%)
3	1987	39.8%
4	1291	25.9%
2	1097	22.0%
1	456	9.1%
0	158	3.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	158	3.2%
1	456	9.1%
2	1097	22.0%
3	1987	39.8%
4	1291	25.9%

Value	Count	Frequency (%)
4	1291	25.9%
3	1987	39.8%
2	1097	22.0%
1	456	9.1%
0	158	3.2%

color
Real number (ℝ)

ZEROS

Distinct	7
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.3924634

Minimum	0
Maximum	6
Zeros	248
Zeros (%)	5.0%
Negative	0
Negative (%)	0.0%
Memory size	78.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	3
Q3	5
95-th percentile	6
Maximum	6
Range	6
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.6912647
Coefficient of variation (CV)	0.49853586
Kurtosis	-0.86799405
Mean	3.3924634
Median Absolute Deviation (MAD)	1
Skewness	-0.17106034
Sum	16925
Variance	2.8603762
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=7)

Value	Count	Frequency (%)
3	1095	21.9%
5	917	18.4%
4	843	16.9%
2	762	15.3%
6	607	12.2%
1	517	10.4%
0	248	5.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	248	5.0%
1	517	10.4%
2	762	15.3%
3	1095	21.9%
4	843	16.9%
5	917	18.4%
6	607	12.2%

Value	Count	Frequency (%)
6	607	12.2%
5	917	18.4%
4	843	16.9%
3	1095	21.9%
2	762	15.3%
1	517	10.4%
0	248	5.0%

clarity
Real number (ℝ)

ZEROS

Distinct	8
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.0591301

Minimum	0
Maximum	7
Zeros	64
Zeros (%)	1.3%
Negative	0
Negative (%)	0.0%
Memory size	78.0 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	2
median	3
Q3	4
95-th percentile	6
Maximum	7
Range	7
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.6319016
Coefficient of variation (CV)	0.53345282
Kurtosis	-0.41339557
Mean	3.0591301
Median Absolute Deviation (MAD)	1
Skewness	0.52645335
Sum	15262
Variance	2.6631028
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=8)

Value	Count	Frequency (%)
2	1191	23.9%
3	1131	22.7%
1	843	16.9%
4	801	16.1%
5	464	9.3%
6	345	6.9%
7	150	3.0%
0	64	1.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	64	1.3%
1	843	16.9%
2	1191	23.9%
3	1131	22.7%
4	801	16.1%
5	464	9.3%
6	345	6.9%
7	150	3.0%

Value	Count	Frequency (%)
7	150	3.0%
6	345	6.9%
5	464	9.3%
4	801	16.1%
3	1131	22.7%
2	1191	23.9%
1	843	16.9%
0	64	1.3%

depth
Real number (ℝ)

Distinct	121
Distinct (%)	2.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	61.710844

Minimum	44
Maximum	70.2
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.0 KiB

Quantile statistics

Minimum	44
5-th percentile	59.2
Q1	61
median	61.8
Q3	62.5
95-th percentile	63.8
Maximum	70.2
Range	26.2
Interquartile range (IQR)	1.5

Descriptive statistics

Standard deviation	1.4455628
Coefficient of variation (CV)	0.023424778
Kurtosis	7.1140363
Mean	61.710844
Median Absolute Deviation (MAD)	0.7
Skewness	-0.44943877
Sum	307875.4
Variance	2.0896518
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
62	225	4.5%
61.6	203	4.1%
62.1	193	3.9%
62.2	191	3.8%
61.9	186	3.7%
62.3	182	3.6%
61.8	178	3.6%
61.5	177	3.5%
61.7	169	3.4%
61.3	147	2.9%
Other values (111)	3138	62.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
44	1	< 0.1%
53	1	< 0.1%
55.3	1	< 0.1%
55.8	2	< 0.1%
55.9	1	< 0.1%
56.3	3	0.1%
56.5	2	< 0.1%
56.6	1	< 0.1%
56.7	3	0.1%
56.8	3	0.1%

Value	Count	Frequency (%)
70.2	1	< 0.1%
69.8	2	< 0.1%
69.6	1	< 0.1%
68.6	1	< 0.1%
68.5	1	< 0.1%
68.1	1	< 0.1%
67.9	1	< 0.1%
67.8	1	< 0.1%
67.6	2	< 0.1%
67.5	1	< 0.1%

table
Real number (ℝ)

Distinct	78
Distinct (%)	1.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	57.446242

Minimum	51.6
Maximum	95
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.0 KiB

Quantile statistics

Minimum	51.6
5-th percentile	54
Q1	56
median	57
Q3	59
95-th percentile	61
Maximum	95
Range	43.4
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	2.2597522
Coefficient of variation (CV)	0.039336815
Kurtosis	15.525537
Mean	57.446242
Median Absolute Deviation (MAD)	1
Skewness	1.4787667
Sum	286599.3
Variance	5.10648
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
56	918	18.4%
57	888	17.8%
58	765	15.3%
59	640	12.8%
55	584	11.7%
60	361	7.2%
54	236	4.7%
61	209	4.2%
62	121	2.4%
63	59	1.2%
Other values (68)	208	4.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
51.6	1	< 0.1%
52	6	0.1%
53	50	1.0%
53.1	1	< 0.1%
53.3	1	< 0.1%
53.4	1	< 0.1%
53.5	2	< 0.1%
53.6	1	< 0.1%
53.7	2	< 0.1%
53.8	5	0.1%

Value	Count	Frequency (%)
95	1	< 0.1%
70	1	< 0.1%
68	1	< 0.1%
67	1	< 0.1%
66	7	0.1%
65.4	1	< 0.1%
65	8	0.2%
64.2	1	< 0.1%
64	26	0.5%
63	59	1.2%

price
Real number (ℝ)

HIGH CORRELATION

Distinct	3177
Distinct (%)	63.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3930.5819

Minimum	351
Maximum	18787
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.0 KiB

Quantile statistics

Minimum	351
5-th percentile	544
Q1	942
median	2398
Q3	5376
95-th percentile	12925.8
Maximum	18787
Range	18436
Interquartile range (IQR)	4434

Descriptive statistics

Standard deviation	3970.9233
Coefficient of variation (CV)	1.0102635
Kurtosis	2.079043
Mean	3930.5819
Median Absolute Deviation (MAD)	1689
Skewness	1.5874644
Sum	19609673
Variance	15768232
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
776	15	0.3%
765	15	0.3%
605	15	0.3%
561	14	0.3%
698	14	0.3%
625	13	0.3%
526	13	0.3%
544	13	0.3%
552	12	0.2%
878	11	0.2%
Other values (3167)	4854	97.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
351	2	< 0.1%
357	2	< 0.1%
361	1	< 0.1%
362	1	< 0.1%
363	1	< 0.1%
367	1	< 0.1%
373	1	< 0.1%
377	1	< 0.1%
383	1	< 0.1%
384	2	< 0.1%

Value	Count	Frequency (%)
18787	1	< 0.1%
18777	1	< 0.1%
18741	1	< 0.1%
18705	1	< 0.1%
18656	1	< 0.1%
18541	1	< 0.1%
18515	1	< 0.1%
18493	1	< 0.1%
18445	1	< 0.1%
18430	1	< 0.1%

x
Real number (ℝ)

HIGH CORRELATION

Distinct	473
Distinct (%)	9.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.7262317

Minimum	3.86
Maximum	10
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.0 KiB

Quantile statistics

Minimum	3.86
5-th percentile	4.29
Q1	4.7
median	5.69
Q3	6.54
95-th percentile	7.616
Maximum	10
Range	6.14
Interquartile range (IQR)	1.84

Descriptive statistics

Standard deviation	1.1162571
Coefficient of variation (CV)	0.19493747
Kurtosis	-0.74825981
Mean	5.7262317
Median Absolute Deviation (MAD)	0.92
Skewness	0.37771921
Sum	28568.17
Variance	1.24603
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.37	50	1.0%
4.38	49	1.0%
4.34	46	0.9%
4.35	45	0.9%
4.32	44	0.9%
4.31	40	0.8%
4.4	37	0.7%
4.29	35	0.7%
6.43	34	0.7%
4.39	34	0.7%
Other values (463)	4575	91.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3.86	2	< 0.1%
3.88	2	< 0.1%
3.89	1	< 0.1%
3.9	2	< 0.1%
3.91	2	< 0.1%
3.92	4	0.1%
3.93	4	0.1%
3.94	6	0.1%
3.95	3	0.1%
3.96	4	0.1%

Value	Count	Frequency (%)
10	1	< 0.1%
9.44	1	< 0.1%
9.24	1	< 0.1%
8.89	1	< 0.1%
8.87	1	< 0.1%
8.83	1	< 0.1%
8.8	1	< 0.1%
8.72	1	< 0.1%
8.68	1	< 0.1%
8.64	1	< 0.1%

y
Real number (ℝ)

HIGH CORRELATION

Distinct	470
Distinct (%)	9.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.7288214

Minimum	3.84
Maximum	9.85
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.0 KiB

Quantile statistics

Minimum	3.84
5-th percentile	4.29
Q1	4.71
median	5.7
Q3	6.54
95-th percentile	7.586
Maximum	9.85
Range	6.01
Interquartile range (IQR)	1.83

Descriptive statistics

Standard deviation	1.1091668
Coefficient of variation (CV)	0.19361169
Kurtosis	-0.76715725
Mean	5.7288214
Median Absolute Deviation (MAD)	0.92
Skewness	0.36905777
Sum	28581.09
Variance	1.2302509
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.34	52	1.0%
4.39	42	0.8%
4.35	39	0.8%
4.37	39	0.8%
4.41	39	0.8%
4.32	39	0.8%
4.38	37	0.7%
4.33	36	0.7%
4.29	35	0.7%
4.4	35	0.7%
Other values (460)	4596	92.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
3.84	1	< 0.1%
3.89	2	< 0.1%
3.9	2	< 0.1%
3.92	1	< 0.1%
3.93	1	< 0.1%
3.94	2	< 0.1%
3.95	6	0.1%
3.96	5	0.1%
3.97	4	0.1%
3.98	3	0.1%

Value	Count	Frequency (%)
9.85	1	< 0.1%
9.37	1	< 0.1%
9.13	1	< 0.1%
8.93	1	< 0.1%
8.87	1	< 0.1%
8.83	1	< 0.1%
8.78	1	< 0.1%
8.66	1	< 0.1%
8.65	1	< 0.1%
8.62	1	< 0.1%

z
Real number (ℝ)

HIGH CORRELATION

Distinct	303
Distinct (%)	6.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.5336781

Minimum	1.41
Maximum	6.43
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	78.0 KiB

Quantile statistics

Minimum	1.41
5-th percentile	2.65
Q1	2.9
median	3.53
Q3	4.03
95-th percentile	4.68
Maximum	6.43
Range	5.02
Interquartile range (IQR)	1.13

Descriptive statistics

Standard deviation	0.68843703
Coefficient of variation (CV)	0.19482166
Kurtosis	-0.71092728
Mean	3.5336781
Median Absolute Deviation (MAD)	0.57
Skewness	0.37583713
Sum	17629.52
Variance	0.47394555
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.69	77	1.5%
2.73	72	1.4%
2.72	71	1.4%
2.71	66	1.3%
2.7	66	1.3%
2.68	64	1.3%
2.67	59	1.2%
2.74	58	1.2%
4.02	56	1.1%
3.99	55	1.1%
Other values (293)	4345	87.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.41	1	< 0.1%
2.35	1	< 0.1%
2.37	1	< 0.1%
2.38	1	< 0.1%
2.39	2	< 0.1%
2.4	2	< 0.1%
2.41	1	< 0.1%
2.42	4	0.1%
2.43	6	0.1%
2.44	10	0.2%

Value	Count	Frequency (%)
6.43	1	< 0.1%
6.16	1	< 0.1%
5.73	1	< 0.1%
5.62	1	< 0.1%
5.6	1	< 0.1%
5.53	1	< 0.1%
5.43	1	< 0.1%
5.42	1	< 0.1%
5.41	1	< 0.1%
5.39	1	< 0.1%

Auto

Heatmap
Table

	carat	clarity	color	cut	depth	price	table	x	y	z
carat	1.000	-0.346	-0.243	0.020	-0.004	0.962	0.205	0.997	0.996	0.994
clarity	-0.346	1.000	-0.042	0.042	-0.070	-0.180	-0.147	-0.342	-0.337	-0.348
color	-0.243	-0.042	1.000	-0.032	-0.025	-0.142	-0.035	-0.239	-0.239	-0.244
cut	0.020	0.042	-0.032	1.000	-0.288	0.039	0.073	0.041	0.024	-0.006
depth	-0.004	-0.070	-0.025	-0.288	1.000	-0.020	-0.264	-0.058	-0.059	0.072
price	0.962	-0.180	-0.142	0.039	-0.020	1.000	0.183	0.963	0.962	0.957
table	0.205	-0.147	-0.035	0.073	-0.264	0.183	1.000	0.214	0.206	0.170
x	0.997	-0.342	-0.239	0.041	-0.058	0.963	0.214	1.000	0.998	0.988
y	0.996	-0.337	-0.239	0.024	-0.059	0.962	0.206	0.998	1.000	0.987
z	0.994	-0.348	-0.244	-0.006	0.072	0.957	0.170	0.988	0.987	1.000

Most frequently occurring

	carat	cut	color	clarity	depth	table	price	x	y	z	# duplicates
0	0.31	4	5	3	61.6	59.0	872	4.35	4.32	2.67	2

Overview

Variables

Interactions

Correlations

Duplicate rows

Most frequently occurring